$post = $DB->query('SELECT up.*, p.*, u.id,u.name,u.usergroupid,u.gender,u.qq,u.uc,u.popo,u.email,u.joindate,u.quintessence, u.posts, u.lastvisit, u.lastactivity,u.options,u.customtitle,u.options, u.signature, u.location, u.award_data, u.avatarlocation, u.avatartype, u.avatarsize, u.bank, u.mkaccount, u.onlinetime, g.canblog, e.loanamount, m.forumid as moderatorfid 
			FROM ' . TABLE_PREFIX . 'post p
				LEFT JOIN ' . TABLE_PREFIX . 'user u ON (p.userid = u.id)
				LEFT JOIN ' . TABLE_PREFIX . 'usergroup g ON (g.usergroupid = u.usergroupid)
				LEFT JOIN ' . TABLE_PREFIX . 'userextra e ON (p.userid = e.id)
				LEFT JOIN ' . TABLE_PREFIX . 'userexpand up ON (up.id = p.userid)
				LEFT JOIN ' . TABLE_PREFIX . "moderator m ON (p.userid = m.userid AND m.forumid = '{$this->thread['forumid']}')
			WHERE p.threadid = '{$this->thread['tid']}'  $moderate ".$addsql."
			ORDER BY p.pid
			LIMIT {$this->pp}, {$this->maxposts}");